<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.20"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>libxlsxwriter: lxw_data_validation Struct Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="customdoxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">libxlsxwriter
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.20 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

</div><!-- top -->
<div class="header">
  <div class="summary">
<a href="#pub-attribs">Data Fields</a>  </div>
  <div class="headertitle">
<div class="title">lxw_data_validation Struct Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>Worksheet data validation options.  
 <a href="structlxw__data__validation.html#details">More...</a></p>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock"><dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#_a9">data_validate.c</a>.</dd>
</dl>
</div><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a>
Data Fields</h2></td></tr>
<tr class="memitem:a4495d388fd38d3824db6d8b7af3cdecc"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a4495d388fd38d3824db6d8b7af3cdecc">validate</a></td></tr>
<tr class="separator:a4495d388fd38d3824db6d8b7af3cdecc"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a7d648cb7da5e14cb1ba1c446cd91f93f"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a7d648cb7da5e14cb1ba1c446cd91f93f">criteria</a></td></tr>
<tr class="separator:a7d648cb7da5e14cb1ba1c446cd91f93f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1ca1d3d0e6fdf634034228713ef5d34c"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a1ca1d3d0e6fdf634034228713ef5d34c">ignore_blank</a></td></tr>
<tr class="separator:a1ca1d3d0e6fdf634034228713ef5d34c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9afa5c82f4d99384298ed4d16facc5cb"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a9afa5c82f4d99384298ed4d16facc5cb">show_input</a></td></tr>
<tr class="separator:a9afa5c82f4d99384298ed4d16facc5cb"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a42c258e5be3b33f28215f185a341b31d"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a42c258e5be3b33f28215f185a341b31d">show_error</a></td></tr>
<tr class="separator:a42c258e5be3b33f28215f185a341b31d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aee937cbcbba81e8d6261705686699529"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#aee937cbcbba81e8d6261705686699529">error_type</a></td></tr>
<tr class="separator:aee937cbcbba81e8d6261705686699529"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a18e5d9f622c710bd3997164f67871eb2"><td class="memItemLeft" align="right" valign="top">uint8_t&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a18e5d9f622c710bd3997164f67871eb2">dropdown</a></td></tr>
<tr class="separator:a18e5d9f622c710bd3997164f67871eb2"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae57eda5fa066ce0d318f290a759631b7"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#ae57eda5fa066ce0d318f290a759631b7">value_number</a></td></tr>
<tr class="separator:ae57eda5fa066ce0d318f290a759631b7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aba116e382c2276bd68fd910a73b6bf64"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#aba116e382c2276bd68fd910a73b6bf64">value_formula</a></td></tr>
<tr class="separator:aba116e382c2276bd68fd910a73b6bf64"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a7168c44107ed6b5c63f6b701b69cc50b"><td class="memItemLeft" align="right" valign="top">char **&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a7168c44107ed6b5c63f6b701b69cc50b">value_list</a></td></tr>
<tr class="separator:a7168c44107ed6b5c63f6b701b69cc50b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a88b1a98df0ec6ca3509a2af95ff80b5e"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structlxw__datetime.html">lxw_datetime</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a88b1a98df0ec6ca3509a2af95ff80b5e">value_datetime</a></td></tr>
<tr class="separator:a88b1a98df0ec6ca3509a2af95ff80b5e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:acc19c667d02e2e5e917216bc077b2ade"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#acc19c667d02e2e5e917216bc077b2ade">minimum_number</a></td></tr>
<tr class="separator:acc19c667d02e2e5e917216bc077b2ade"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5103f918e00ebc26d50adda3b4cd3026"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a5103f918e00ebc26d50adda3b4cd3026">minimum_formula</a></td></tr>
<tr class="separator:a5103f918e00ebc26d50adda3b4cd3026"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9879f8968affead0bc9245ade4ae32aa"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structlxw__datetime.html">lxw_datetime</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a9879f8968affead0bc9245ade4ae32aa">minimum_datetime</a></td></tr>
<tr class="separator:a9879f8968affead0bc9245ade4ae32aa"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abc1601dcfcd8e7d7172984fb34e14626"><td class="memItemLeft" align="right" valign="top">double&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#abc1601dcfcd8e7d7172984fb34e14626">maximum_number</a></td></tr>
<tr class="separator:abc1601dcfcd8e7d7172984fb34e14626"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab1acd165475bda9af44e8e27d93c0df3"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#ab1acd165475bda9af44e8e27d93c0df3">maximum_formula</a></td></tr>
<tr class="separator:ab1acd165475bda9af44e8e27d93c0df3"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa1c41a46845b8dbbbba0c249517e9530"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structlxw__datetime.html">lxw_datetime</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#aa1c41a46845b8dbbbba0c249517e9530">maximum_datetime</a></td></tr>
<tr class="separator:aa1c41a46845b8dbbbba0c249517e9530"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a93759c9248dd4a2f298a18f04db55a3b"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a93759c9248dd4a2f298a18f04db55a3b">input_title</a></td></tr>
<tr class="separator:a93759c9248dd4a2f298a18f04db55a3b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0bb3f10cde1f055b844c10a2a75f0ac6"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a0bb3f10cde1f055b844c10a2a75f0ac6">input_message</a></td></tr>
<tr class="separator:a0bb3f10cde1f055b844c10a2a75f0ac6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3d2c14ba7d150130b18ee90e7bdea9c4"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#a3d2c14ba7d150130b18ee90e7bdea9c4">error_title</a></td></tr>
<tr class="separator:a3d2c14ba7d150130b18ee90e7bdea9c4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad021ae9515ce8624db6819667dc10dc9"><td class="memItemLeft" align="right" valign="top">char *&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="structlxw__data__validation.html#ad021ae9515ce8624db6819667dc10dc9">error_message</a></td></tr>
<tr class="separator:ad021ae9515ce8624db6819667dc10dc9"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Field Documentation</h2>
<a id="a4495d388fd38d3824db6d8b7af3cdecc"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a4495d388fd38d3824db6d8b7af3cdecc">&#9670;&nbsp;</a></span>validate</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::validate</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>Set the validation type. Should be a <a class="el" href="worksheet_8h.html#a20e0dbd70400f2eb7c5d88696f812b4c">lxw_validation_types</a> value. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a21">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a7d648cb7da5e14cb1ba1c446cd91f93f"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a7d648cb7da5e14cb1ba1c446cd91f93f">&#9670;&nbsp;</a></span>criteria</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::criteria</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>Set the validation criteria type to select the data. Should be a <a class="el" href="worksheet_8h.html#a88eed033ce0af97d5151528bc514fbf5">lxw_validation_criteria</a> value. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a23">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a1ca1d3d0e6fdf634034228713ef5d34c"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1ca1d3d0e6fdf634034228713ef5d34c">&#9670;&nbsp;</a></span>ignore_blank</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::ignore_blank</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>Controls whether a data validation is not applied to blank data in the cell. Should be a <a class="el" href="worksheet_8h.html#a00c0cb6be9a2864d2a4cc977eadea74b">lxw_validation_boolean</a> value. It is on by default. </p>

</div>
</div>
<a id="a9afa5c82f4d99384298ed4d16facc5cb"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9afa5c82f4d99384298ed4d16facc5cb">&#9670;&nbsp;</a></span>show_input</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::show_input</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to toggle on and off the 'Show input message when cell is selected' option in the Excel data validation dialog. When the option is off an input message is not displayed even if it has been set using input_message. Should be a <a class="el" href="worksheet_8h.html#a00c0cb6be9a2864d2a4cc977eadea74b">lxw_validation_boolean</a> value. It is on by default. </p>

</div>
</div>
<a id="a42c258e5be3b33f28215f185a341b31d"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a42c258e5be3b33f28215f185a341b31d">&#9670;&nbsp;</a></span>show_error</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::show_error</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to toggle on and off the 'Show error alert after invalid data is entered' option in the Excel data validation dialog. When the option is off an error message is not displayed even if it has been set using error_message. Should be a <a class="el" href="worksheet_8h.html#a00c0cb6be9a2864d2a4cc977eadea74b">lxw_validation_boolean</a> value. It is on by default. </p>

</div>
</div>
<a id="aee937cbcbba81e8d6261705686699529"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aee937cbcbba81e8d6261705686699529">&#9670;&nbsp;</a></span>error_type</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::error_type</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to specify the type of error dialog that is displayed. Should be a <a class="el" href="worksheet_8h.html#a814e4b2e983125351c617e44b73b8998">lxw_validation_error_types</a> value. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a48">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a18e5d9f622c710bd3997164f67871eb2"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a18e5d9f622c710bd3997164f67871eb2">&#9670;&nbsp;</a></span>dropdown</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">uint8_t lxw_data_validation::dropdown</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to toggle on and off the 'In-cell dropdown' option in the Excel data validation dialog. When the option is on a dropdown list will be shown for list validations. Should be a <a class="el" href="worksheet_8h.html#a00c0cb6be9a2864d2a4cc977eadea74b">lxw_validation_boolean</a> value. It is on by default. </p>

</div>
</div>
<a id="ae57eda5fa066ce0d318f290a759631b7"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae57eda5fa066ce0d318f290a759631b7">&#9670;&nbsp;</a></span>value_number</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_data_validation::value_number</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to set the limiting value to which the criteria is applied using a whole or decimal number. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a32">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="aba116e382c2276bd68fd910a73b6bf64"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aba116e382c2276bd68fd910a73b6bf64">&#9670;&nbsp;</a></span>value_formula</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::value_formula</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to set the limiting value to which the criteria is applied using a cell reference. It is valid for any of the <code>_FORMULA</code> validation types. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a37">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a7168c44107ed6b5c63f6b701b69cc50b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a7168c44107ed6b5c63f6b701b69cc50b">&#9670;&nbsp;</a></span>value_list</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char** lxw_data_validation::value_list</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to set a list of strings for a drop down list. The list should be a <code>NULL</code> terminated array of char* strings:</p>
<div class="fragment"><div class="line"><span class="keywordtype">char</span> *list[] = {<span class="stringliteral">&quot;open&quot;</span>, <span class="stringliteral">&quot;high&quot;</span>, <span class="stringliteral">&quot;close&quot;</span>, NULL};</div>
<div class="line"> </div>
<div class="line">data_validation-&gt;<a class="code" href="structlxw__data__validation.html#a4495d388fd38d3824db6d8b7af3cdecc">validate</a>   = <a class="code" href="worksheet_8h.html#a20e0dbd70400f2eb7c5d88696f812b4ca7d721cc2b76618d8d2fb105ca4717de0">LXW_VALIDATION_TYPE_LIST</a>;</div>
<div class="line">data_validation-&gt;<a class="code" href="structlxw__data__validation.html#a7168c44107ed6b5c63f6b701b69cc50b">value_list</a> = list;</div>
</div><!-- fragment --><p>The <code>value_formula</code> parameter can also be used to specify a list from an Excel cell range.</p>
<p>Note, the string list is restricted by Excel to 255 characters, including comma separators. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a36">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a88b1a98df0ec6ca3509a2af95ff80b5e"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a88b1a98df0ec6ca3509a2af95ff80b5e">&#9670;&nbsp;</a></span>value_datetime</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="structlxw__datetime.html">lxw_datetime</a> lxw_data_validation::value_datetime</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is used to set the limiting value to which the date or time criteria is applied using a <a class="el" href="structlxw__datetime.html" title="Struct to represent a date and time in Excel.">lxw_datetime</a> struct. </p>

</div>
</div>
<a id="acc19c667d02e2e5e917216bc077b2ade"></a>
<h2 class="memtitle"><span class="permalink"><a href="#acc19c667d02e2e5e917216bc077b2ade">&#9670;&nbsp;</a></span>minimum_number</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_data_validation::minimum_number</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is the same as <code>value_number</code> but for the minimum value when a <code>BETWEEN</code> criteria is used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a25">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a5103f918e00ebc26d50adda3b4cd3026"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a5103f918e00ebc26d50adda3b4cd3026">&#9670;&nbsp;</a></span>minimum_formula</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::minimum_formula</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is the same as <code>value_formula</code> but for the minimum value when a <code>BETWEEN</code> criteria is used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a29">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a9879f8968affead0bc9245ade4ae32aa"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9879f8968affead0bc9245ade4ae32aa">&#9670;&nbsp;</a></span>minimum_datetime</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="structlxw__datetime.html">lxw_datetime</a> lxw_data_validation::minimum_datetime</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is the same as <code>value_datetime</code> but for the minimum value when a <code>BETWEEN</code> criteria is used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a40">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="abc1601dcfcd8e7d7172984fb34e14626"></a>
<h2 class="memtitle"><span class="permalink"><a href="#abc1601dcfcd8e7d7172984fb34e14626">&#9670;&nbsp;</a></span>maximum_number</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">double lxw_data_validation::maximum_number</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is the same as <code>value_number</code> but for the maximum value when a <code>BETWEEN</code> criteria is used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a26">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="ab1acd165475bda9af44e8e27d93c0df3"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ab1acd165475bda9af44e8e27d93c0df3">&#9670;&nbsp;</a></span>maximum_formula</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::maximum_formula</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is the same as <code>value_formula</code> but for the maximum value when a <code>BETWEEN</code> criteria is used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a30">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="aa1c41a46845b8dbbbba0c249517e9530"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa1c41a46845b8dbbbba0c249517e9530">&#9670;&nbsp;</a></span>maximum_datetime</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="structlxw__datetime.html">lxw_datetime</a> lxw_data_validation::maximum_datetime</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>This parameter is the same as <code>value_datetime</code> but for the maximum value when a <code>BETWEEN</code> criteria is used. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a41">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a93759c9248dd4a2f298a18f04db55a3b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a93759c9248dd4a2f298a18f04db55a3b">&#9670;&nbsp;</a></span>input_title</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::input_title</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The input_title parameter is used to set the title of the input message that is displayed when a cell is entered. It has no default value and is only displayed if the input message is displayed. See the <code>input_message</code> parameter below.</p>
<p>The maximum title length is 32 characters. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a44">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a0bb3f10cde1f055b844c10a2a75f0ac6"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a0bb3f10cde1f055b844c10a2a75f0ac6">&#9670;&nbsp;</a></span>input_message</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::input_message</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The input_message parameter is used to set the input message that is displayed when a cell is entered. It has no default value.</p>
<p>The message can be split over several lines using newlines. The maximum message length is 255 characters. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a45">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="a3d2c14ba7d150130b18ee90e7bdea9c4"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a3d2c14ba7d150130b18ee90e7bdea9c4">&#9670;&nbsp;</a></span>error_title</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::error_title</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The error_title parameter is used to set the title of the error message that is displayed when the data validation criteria is not met. The default error title is 'Microsoft Excel'. The maximum title length is 32 characters. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a46">data_validate.c</a>.</dd>
</dl>

</div>
</div>
<a id="ad021ae9515ce8624db6819667dc10dc9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ad021ae9515ce8624db6819667dc10dc9">&#9670;&nbsp;</a></span>error_message</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">char* lxw_data_validation::error_message</td>
        </tr>
      </table>
</div><div class="memdoc">
<p>The error_message parameter is used to set the error message that is displayed when a cell is entered. The default error message is "The value you entered is not valid. A user has restricted values that can be entered into the cell".</p>
<p>The message can be split over several lines using newlines. The maximum message length is 255 characters. </p>
<dl class="section examples"><dt>Examples</dt><dd><a class="el" href="data_validate_8c-example.html#a47">data_validate.c</a>.</dd>
</dl>

</div>
</div>
</div><!-- contents -->
<div class="ttc" id="astructlxw__data__validation_html_a7168c44107ed6b5c63f6b701b69cc50b"><div class="ttname"><a href="structlxw__data__validation.html#a7168c44107ed6b5c63f6b701b69cc50b">lxw_data_validation::value_list</a></div><div class="ttdeci">char ** value_list</div><div class="ttdef"><b>Definition:</b> worksheet.h:877</div></div>
<div class="ttc" id="aworksheet_8h_html_a20e0dbd70400f2eb7c5d88696f812b4ca7d721cc2b76618d8d2fb105ca4717de0"><div class="ttname"><a href="worksheet_8h.html#a20e0dbd70400f2eb7c5d88696f812b4ca7d721cc2b76618d8d2fb105ca4717de0">LXW_VALIDATION_TYPE_LIST</a></div><div class="ttdeci">@ LXW_VALIDATION_TYPE_LIST</div><div class="ttdef"><b>Definition:</b> worksheet.h:124</div></div>
<div class="ttc" id="astructlxw__data__validation_html_a4495d388fd38d3824db6d8b7af3cdecc"><div class="ttname"><a href="structlxw__data__validation.html#a4495d388fd38d3824db6d8b7af3cdecc">lxw_data_validation::validate</a></div><div class="ttdeci">uint8_t validate</div><div class="ttdef"><b>Definition:</b> worksheet.h:801</div></div>
<!-- HTML footer for doxygen 1.8.20-->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Copyright 2014-2020 John McNamara.
Generated by&#160;<a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20
</small></address>
</body>
</html>
